package com.example.tutorialmongodb.syncdata.mapper;

import com.example.tutorialmongodb.syncdata.model.UserLoginPromotionChannelEntity;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author: cph
 * @date: 2021/11/11 14:08
 */
@Repository
public interface SyncDataMapper {

    @Select(
            "SELECT t.id,t.user_id AS userId,t.tuiguang_id AS tuiguangId,t.generalize_id AS generalizeId,t.url AS url,t.update_time AS updateTime \n"
                    + "FROM yb_media_user_login_promotion_channel t WHERE t.id > 53472465 AND t.update_time BETWEEN '2021-10-29 14:00:00' AND '2021-10-29 15:30:00' \n"
                    + "ORDER BY update_time")
    List<UserLoginPromotionChannelEntity> findList();
}
